Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	81412
Missing cells	6682
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.7 MiB
Average record size in memory	202.0 B

Variable types

Numeric	10
Categorical	22
Boolean	1

Alerts

`diag_1` has a high cardinality: 701 distinct values	High cardinality
`diag_2` has a high cardinality: 725 distinct values	High cardinality
`diag_3` has a high cardinality: 761 distinct values	High cardinality
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`admission_source_code` is highly correlated with `admission_type_code`	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `diabetesMed` and 1 other fields	High correlation
`admission_type_code` is highly correlated with `admission_source_code`	High correlation
`change` is highly correlated with `diabetesMed` and 1 other fields	High correlation
`gender` is highly correlated with `hemoglobin_level`	High correlation
`admission_type_code` is highly correlated with `admission_source_code`	High correlation
`admission_source_code` is highly correlated with `admission_type_code` and 2 other fields	High correlation
`medical_specialty` is highly correlated with `admission_source_code`	High correlation
`hemoglobin_level` is highly correlated with `gender`	High correlation
`max_glu_serum` is highly correlated with `admission_source_code`	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`admission_type_code` has 1162 (1.4%) missing values	Missing
`num_lab_procedures` has 1493 (1.8%) missing values	Missing
`num_medications` has 2678 (3.3%) missing values	Missing
`diag_2` has 1349 (1.7%) missing values	Missing
`num_procedures` has 37355 (45.9%) zeros	Zeros
`number_outpatient` has 67984 (83.5%) zeros	Zeros
`number_emergency` has 72350 (88.9%) zeros	Zeros
`number_inpatient` has 53995 (66.3%) zeros	Zeros

Reproduction

Analysis started	2022-02-01 18:26:58.180676
Analysis finished	2022-02-01 18:27:33.856248
Duration	35.68 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

patient_id
Real number (ℝ_≥0)

Distinct	60069
Distinct (%)	73.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108639531.1

Minimum	198
Maximum	379005166
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	198
5-th percentile	2914233.3
Q1	46839060
median	90834372
Q3	175111722
95-th percentile	222996661.2
Maximum	379005166
Range	379004968
Interquartile range (IQR)	128272662

Descriptive statistics

Standard deviation	77324533.16
Coefficient of variation (CV)	0.7117531928
Kurtosis	-0.3648068986
Mean	108639531.1
Median Absolute Deviation (MAD)	65849112
Skewness	0.4666683655
Sum	8.844561509 × 10¹²
Variance	5.979083428 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177571710	33	< 0.1%
176455008	20	< 0.1%
181219536	19	< 0.1%
185418630	18	< 0.1%
47286738	18	< 0.1%
3320514	18	< 0.1%
182320488	17	< 0.1%
46397970	17	< 0.1%
86281740	16	< 0.1%
168857154	16	< 0.1%
Other values (60059)	81220	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
198	2	< 0.1%
684	1	< 0.1%
1386	1	< 0.1%
1476	1	< 0.1%
1782	1	< 0.1%
2232	4	< 0.1%
2538	1	< 0.1%
2556	3	< 0.1%
3186	1	< 0.1%
3978	1	< 0.1%

Value	Count	Frequency (%)
379005166	1	< 0.1%
378702118	1	< 0.1%
378698788	1	< 0.1%
378664102	1	< 0.1%
378515620	1	< 0.1%
378431452	1	< 0.1%
378358570	1	< 0.1%
378258634	1	< 0.1%
378194590	1	< 0.1%
378151156	1	< 0.1%

race
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

white	60873
black	15388
unknown/other	3007
hispanic	1627
asian	517

Length

Max length	13
Median length	5
Mean length	5.355439002
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	white
2nd row	white
3rd row	white
4th row	black
5th row	white

Common Values

Value	Count	Frequency (%)
white	60873	74.8%
black	15388	18.9%
unknown/other	3007	3.7%
hispanic	1627	2.0%
asian	517	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
white	60873	74.8%
black	15388	18.9%
unknown/other	3007	3.7%
hispanic	1627	2.0%
asian	517	0.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

gender
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

female	43719
male	37691
unknown	2

Length

Max length	7
Median length	6
Mean length	5.074092271
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	male
2nd row	male
3rd row	female
4th row	female
5th row	female

Common Values

Value	Count	Frequency (%)
female	43719	53.7%
male	37691	46.3%
unknown	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
female	43719	53.7%
male	37691	46.3%
unknown	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

age
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.9 KiB

70-80	20261
60-70	17414
50-60	13414
80-90	13383
40-50	7498
Other values (6)	9442

Length

Max length	7
Median length	5
Mean length	5.082395716
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	50-60
2nd row	80-90
3rd row	60-70
4th row	70-80
5th row	unknown

Common Values

Value	Count	Frequency (%)
70-80	20261	24.9%
60-70	17414	21.4%
50-60	13414	16.5%
80-90	13383	16.4%
40-50	7498	9.2%
30-40	2964	3.6%
unknown	2336	2.9%
90-100	2172	2.7%
20-30	1297	1.6%
10-20	537	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
70-80	20261	24.9%
60-70	17414	21.4%
50-60	13414	16.5%
80-90	13383	16.4%
40-50	7498	9.2%
30-40	2964	3.6%
unknown	2336	2.9%
90-100	2172	2.7%
20-30	1297	1.6%
10-20	537	0.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

weight
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.9 KiB

unknown	78913
75-100	1037
50-75	713
100-125	482
125-150	117
Other values (5)	150

Length

Max length	7
Median length	7
Mean length	6.966393161
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	unknown
3rd row	unknown
4th row	unknown
5th row	unknown

Common Values

Value	Count	Frequency (%)
unknown	78913	96.9%
75-100	1037	1.3%
50-75	713	0.9%
100-125	482	0.6%
125-150	117	0.1%
25-50	72	0.1%
0-25	40	< 0.1%
150-175	27	< 0.1%
175-200	8	< 0.1%
>200	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	78913	96.9%
75-100	1037	1.3%
50-75	713	0.9%
100-125	482	0.6%
125-150	117	0.1%
25-50	72	0.1%
0-25	40	< 0.1%
150-175	27	< 0.1%
175-200	8	< 0.1%
200	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

admission_type_code
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	1162
Missing (%)	1.4%
Memory size	715.8 KiB

emergency	42562
elective	14884
urgent	14576
n/a	8204
trauma	16

Length

Max length	9
Median length	9
Mean length	7.655451713
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	elective
2nd row	urgent
3rd row	emergency
4th row	n/a
5th row	emergency

Common Values

Value	Count	Frequency (%)
emergency	42562	52.3%
elective	14884	18.3%
urgent	14576	17.9%
n/a	8204	10.1%
trauma	16	< 0.1%
newborn	8	< 0.1%
(Missing)	1162	1.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
emergency	42562	53.0%
elective	14884	18.5%
urgent	14576	18.2%
n/a	8204	10.2%
trauma	16	< 0.1%
newborn	8	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

discharge_disposition_code
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.9 KiB

discharged_home	47854
transferred_inpatient	16501
home_care	10329
unknown	4276
expired	1317
Other values (3)	1135

Length

Max length	22
Median length	15
Mean length	14.88597504
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	discharged_home
2nd row	discharged_home
3rd row	discharged_home
4th row	discharged_home
5th row	transferred_inpatient

Common Values

Value	Count	Frequency (%)
discharged_home	47854	58.8%
transferred_inpatient	16501	20.3%
home_care	10329	12.7%
unknown	4276	5.3%
expired	1317	1.6%
discharged_hospice	608	0.7%
left_ama	506	0.6%
transferred_outpatient	21	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
discharged_home	47854	58.8%
transferred_inpatient	16501	20.3%
home_care	10329	12.7%
unknown	4276	5.3%
expired	1317	1.6%
discharged_hospice	608	0.7%
left_ama	506	0.6%
transferred_outpatient	21	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

admission_source_code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.7 KiB

emergency	45942
referral	24710
unknown	5661
transfer	5099

Length

Max length	9
Median length	9
Mean length	8.494779639
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	referral
2nd row	emergency
3rd row	emergency
4th row	unknown
5th row	emergency

Common Values

Value	Count	Frequency (%)
emergency	45942	56.4%
referral	24710	30.4%
unknown	5661	7.0%
transfer	5099	6.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
emergency	45942	56.4%
referral	24710	30.4%
unknown	5661	7.0%
transfer	5099	6.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

time_in_hospital
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.395924434

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	11
Maximum	14
Range	13
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.975844099
Coefficient of variation (CV)	0.6769552444
Kurtosis	0.8490950317
Mean	4.395924434
Median Absolute Deviation (MAD)	2
Skewness	1.130728188
Sum	357881
Variance	8.855648103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	14223	17.5%
2	13723	16.9%
1	11302	13.9%
4	11228	13.8%
5	7975	9.8%
6	6059	7.4%
7	4717	5.8%
8	3528	4.3%
9	2372	2.9%
10	1886	2.3%
Other values (4)	4399	5.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11302	13.9%
2	13723	16.9%
3	14223	17.5%
4	11228	13.8%
5	7975	9.8%
6	6059	7.4%
7	4717	5.8%
8	3528	4.3%
9	2372	2.9%
10	1886	2.3%

Value	Count	Frequency (%)
14	814	1.0%
13	944	1.2%
12	1153	1.4%
11	1488	1.8%
10	1886	2.3%
9	2372	2.9%
8	3528	4.3%
7	4717	5.8%
6	6059	7.4%
5	7975	9.8%

payer_code
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.7 KiB

insured	45131
unknown	32278
SP	4003

Length

Max length	7
Median length	7
Mean length	6.754151722
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	insured
3rd row	insured
4th row	unknown
5th row	insured

Common Values

Value	Count	Frequency (%)
insured	45131	55.4%
unknown	32278	39.6%
SP	4003	4.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
insured	45131	55.4%
unknown	32278	39.6%
sp	4003	4.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

medical_specialty
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	716.3 KiB

unknown	40020
internalmedicine	11712
emergency/trauma	6021
family/generalpractice	5939
cardiology	4273
Other values (20)	13447

Length

Max length	33
Median length	7
Mean length	11.40828133
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	emergency/trauma
3rd row	unknown
4th row	unknown
5th row	unknown

Common Values

Value	Count	Frequency (%)
unknown	40020	49.2%
internalmedicine	11712	14.4%
emergency/trauma	6021	7.4%
family/generalpractice	5939	7.3%
cardiology	4273	5.2%
surgery-general	2473	3.0%
nephrology	1299	1.6%
other	1187	1.5%
orthopedics	1100	1.4%
orthopedics-reconstructive	981	1.2%
Other values (15)	6407	7.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unknown	40020	49.2%
internalmedicine	11712	14.4%
emergency/trauma	6021	7.4%
family/generalpractice	5939	7.3%
cardiology	4273	5.2%
surgery-general	2473	3.0%
nephrology	1299	1.6%
other	1187	1.5%
orthopedics	1100	1.4%
orthopedics-reconstructive	981	1.2%
Other values (15)	6407	7.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

has_prosthesis
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	80550
1	862

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	80550	98.9%
1	862	1.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	80550	98.9%
1	862	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

complete_vaccination_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Complete	67114
Incomplete	13978
None	320

Length

Max length	10
Median length	8
Mean length	8.327666683
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Complete
2nd row	Complete
3rd row	Complete
4th row	Complete
5th row	Complete

Common Values

Value	Count	Frequency (%)
Complete	67114	82.4%
Incomplete	13978	17.2%
None	320	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
complete	67114	82.4%
incomplete	13978	17.2%
none	320	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

num_lab_procedures
Real number (ℝ_≥0)

MISSING

Distinct	115
Distinct (%)	0.1%
Missing	1493
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	43.07119709

Minimum	1
Maximum	132
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	32
median	44
Q3	57
95-th percentile	73
Maximum	132
Range	131
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	19.63040493
Coefficient of variation (CV)	0.4557664114
Kurtosis	-0.2441755168
Mean	43.07119709
Median Absolute Deviation (MAD)	13
Skewness	-0.2404533528
Sum	3442207
Variance	385.3527977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2533	3.1%
43	2207	2.7%
44	1988	2.4%
45	1884	2.3%
38	1764	2.2%
40	1736	2.1%
46	1720	2.1%
41	1718	2.1%
47	1679	2.1%
39	1662	2.0%
Other values (105)	61028	75.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2533	3.1%
2	858	1.1%
3	523	0.6%
4	285	0.4%
5	231	0.3%
6	214	0.3%
7	258	0.3%
8	281	0.3%
9	728	0.9%
10	655	0.8%

Value	Count	Frequency (%)
132	1	< 0.1%
126	1	< 0.1%
121	1	< 0.1%
118	1	< 0.1%
114	2	< 0.1%
113	1	< 0.1%
111	2	< 0.1%
109	3	< 0.1%
108	3	< 0.1%
106	4	< 0.1%

num_procedures
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.341767798

Minimum	0
Maximum	6
Zeros	37355
Zeros (%)	45.9%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.708464781
Coefficient of variation (CV)	1.273293921
Kurtosis	0.8445664498
Mean	1.341767798
Median Absolute Deviation (MAD)	1
Skewness	1.313355194
Sum	109236
Variance	2.918851909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	37355	45.9%
1	16513	20.3%
2	10162	12.5%
3	7548	9.3%
6	3994	4.9%
4	3409	4.2%
5	2431	3.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37355	45.9%
1	16513	20.3%
2	10162	12.5%
3	7548	9.3%
4	3409	4.2%
5	2431	3.0%
6	3994	4.9%

Value	Count	Frequency (%)
6	3994	4.9%
5	2431	3.0%
4	3409	4.2%
3	7548	9.3%
2	10162	12.5%
1	16513	20.3%
0	37355	45.9%

num_medications
Real number (ℝ_≥0)

MISSING

Distinct	73
Distinct (%)	0.1%
Missing	2678
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	16.02442401

Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	10
median	15
Q3	20
95-th percentile	31
Maximum	81
Range	80
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.107234783
Coefficient of variation (CV)	0.5059298717
Kurtosis	3.427614554
Mean	16.02442401
Median Absolute Deviation (MAD)	5
Skewness	1.316139858
Sum	1261667
Variance	65.72725582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	4714	5.8%
12	4636	5.7%
11	4457	5.5%
15	4443	5.5%
14	4436	5.4%
16	4234	5.2%
10	4108	5.0%
17	3817	4.7%
9	3813	4.7%
18	3523	4.3%
Other values (63)	36553	44.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	203	0.2%
2	357	0.4%
3	687	0.8%
4	1107	1.4%
5	1570	1.9%
6	2094	2.6%
7	2662	3.3%
8	3356	4.1%
9	3813	4.7%
10	4108	5.0%

Value	Count	Frequency (%)
81	1	< 0.1%
75	2	< 0.1%
74	1	< 0.1%
70	2	< 0.1%
69	5	< 0.1%
68	6	< 0.1%
67	6	< 0.1%
66	3	< 0.1%
65	8	< 0.1%
64	7	< 0.1%

number_outpatient
Real number (ℝ_≥0)

ZEROS

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3709526851

Minimum	0
Maximum	42
Zeros	67984
Zeros (%)	83.5%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	42
Range	42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.278537861
Coefficient of variation (CV)	3.446633256
Kurtosis	152.4729964
Mean	0.3709526851
Median Absolute Deviation (MAD)	0
Skewness	8.984331589
Sum	30200
Variance	1.634659062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
0	67984	83.5%
1	6862	8.4%
2	2904	3.6%
3	1618	2.0%
4	873	1.1%
5	420	0.5%
6	238	0.3%
7	129	0.2%
8	76	0.1%
9	73	0.1%
Other values (29)	235	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	67984	83.5%
1	6862	8.4%
2	2904	3.6%
3	1618	2.0%
4	873	1.1%
5	420	0.5%
6	238	0.3%
7	129	0.2%
8	76	0.1%
9	73	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
40	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
37	1	< 0.1%
36	1	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	2	< 0.1%
29	2	< 0.1%

number_emergency
Real number (ℝ_≥0)

ZEROS

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1975875792

Minimum	0
Maximum	64
Zeros	72350
Zeros (%)	88.9%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	64
Range	64
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8812896989
Coefficient of variation (CV)	4.460248475
Kurtosis	638.5493694
Mean	0.1975875792
Median Absolute Deviation (MAD)	0
Skewness	16.40885167
Sum	16086
Variance	0.7766715333
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	72350	88.9%
1	6064	7.4%
2	1646	2.0%
3	588	0.7%
4	292	0.4%
5	167	0.2%
6	82	0.1%
7	55	0.1%
8	39	< 0.1%
9	27	< 0.1%
Other values (19)	102	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	72350	88.9%
1	6064	7.4%
2	1646	2.0%
3	588	0.7%
4	292	0.4%
5	167	0.2%
6	82	0.1%
7	55	0.1%
8	39	< 0.1%
9	27	< 0.1%

Value	Count	Frequency (%)
64	1	< 0.1%
46	1	< 0.1%
42	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
25	2	< 0.1%
24	1	< 0.1%
22	4	< 0.1%
21	2	< 0.1%
20	4	< 0.1%

number_inpatient
Real number (ℝ_≥0)

ZEROS

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6377929544

Minimum	0
Maximum	21
Zeros	53995
Zeros (%)	66.3%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	21
Range	21
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.265472414
Coefficient of variation (CV)	1.984142981
Kurtosis	20.83213029
Mean	0.6377929544
Median Absolute Deviation (MAD)	0
Skewness	3.619760625
Sum	51924
Variance	1.60142043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	53995	66.3%
1	15706	19.3%
2	6057	7.4%
3	2747	3.4%
4	1288	1.6%
5	641	0.8%
6	386	0.5%
7	224	0.3%
8	120	0.1%
9	93	0.1%
Other values (11)	155	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	53995	66.3%
1	15706	19.3%
2	6057	7.4%
3	2747	3.4%
4	1288	1.6%
5	641	0.8%
6	386	0.5%
7	224	0.3%
8	120	0.1%
9	93	0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
19	2	< 0.1%
18	1	< 0.1%
17	1	< 0.1%
16	4	< 0.1%
15	7	< 0.1%
14	6	< 0.1%
13	16	< 0.1%
12	30	< 0.1%
11	40	< 0.1%

diag_1
Categorical

HIGH CARDINALITY

Distinct	701
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

428	5429
414	5270
786	3232
410	2914
486	2776
Other values (696)	61791

Length

Max length	6
Median length	3
Mean length	3.17798359
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84 ?
Unique (%)	0.1%

Sample

1st row	721
2nd row	276
3rd row	414
4th row	577
5th row	531

Common Values

Value	Count	Frequency (%)
428	5429	6.7%
414	5270	6.5%
786	3232	4.0%
410	2914	3.6%
486	2776	3.4%
427	2218	2.7%
491	1811	2.2%
715	1691	2.1%
780	1620	2.0%
682	1612	2.0%
Other values (691)	52839	64.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
428	5429	6.7%
414	5270	6.5%
786	3232	4.0%
410	2914	3.6%
486	2776	3.4%
427	2218	2.7%
491	1811	2.2%
715	1691	2.1%
780	1620	2.0%
682	1612	2.0%
Other values (691)	52839	64.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_2
Categorical

HIGH CARDINALITY
MISSING

Distinct	725
Distinct (%)	0.9%
Missing	1349
Missing (%)	1.7%
Memory size	1.2 MiB

276	5296
428	5234
250	4778
427	3949
401	2906
Other values (720)	57900

Length

Max length	6
Median length	3
Mean length	3.166931042
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	126 ?
Unique (%)	0.2%

Sample

1st row	250.6
2nd row	507
3rd row	490
4th row	585
5th row	532

Common Values

Value	Count	Frequency (%)
276	5296	6.5%
428	5234	6.4%
250	4778	5.9%
427	3949	4.9%
401	2906	3.6%
496	2626	3.2%
599	2604	3.2%
403	2252	2.8%
414	2076	2.5%
411	2019	2.5%
Other values (715)	46323	56.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
276	5296	6.6%
428	5234	6.5%
250	4778	6.0%
427	3949	4.9%
401	2906	3.6%
496	2626	3.3%
599	2604	3.3%
403	2252	2.8%
414	2076	2.6%
411	2019	2.5%
Other values (715)	46323	57.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_3
Categorical

HIGH CARDINALITY

Distinct	761
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

250	9166
401	6606
276	4112
428	3734
427	3156
Other values (756)	54638

Length

Max length	6
Median length	3
Mean length	3.111678868
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	114 ?
Unique (%)	0.1%

Sample

1st row	357
2nd row	150
3rd row	250
4th row	250
5th row	562

Common Values

Value	Count	Frequency (%)
250	9166	11.3%
401	6606	8.1%
276	4112	5.1%
428	3734	4.6%
427	3156	3.9%
414	2938	3.6%
496	2090	2.6%
403	1886	2.3%
585	1621	2.0%
272	1605	2.0%
Other values (751)	44498	54.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
250	9166	11.3%
401	6606	8.1%
276	4112	5.1%
428	3734	4.6%
427	3156	3.9%
414	2938	3.6%
496	2090	2.6%
403	1886	2.3%
585	1621	2.0%
272	1605	2.0%
Other values (751)	44498	54.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

number_diagnoses
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.421964821

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	6
median	8
Q3	9
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.931480463
Coefficient of variation (CV)	0.2602384287
Kurtosis	-0.07655270384
Mean	7.421964821
Median Absolute Deviation (MAD)	1
Skewness	-0.8713996895
Sum	604237
Variance	3.730616778
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
9	39501	48.5%
5	9144	11.2%
8	8506	10.4%
7	8379	10.3%
6	8133	10.0%
4	4428	5.4%
3	2238	2.7%
2	824	1.0%
1	167	0.2%
16	38	< 0.1%
Other values (6)	54	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	167	0.2%
2	824	1.0%
3	2238	2.7%
4	4428	5.4%
5	9144	11.2%
6	8133	10.0%
7	8379	10.3%
8	8506	10.4%
9	39501	48.5%
10	14	< 0.1%

Value	Count	Frequency (%)
16	38	< 0.1%
15	8	< 0.1%
14	5	< 0.1%
13	14	< 0.1%
12	5	< 0.1%
11	8	< 0.1%
10	14	< 0.1%
9	39501	48.5%
8	8506	10.4%
7	8379	10.3%

blood_type
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

O+	32053
A+	24744
B+	9218
O-	5689
A-	4826
Other values (3)	4882

Length

Max length	3
Median length	2
Mean length	2.041738319
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A+
2nd row	B+
3rd row	O+
4th row	AB-
5th row	A+

Common Values

Value	Count	Frequency (%)
O+	32053	39.4%
A+	24744	30.4%
B+	9218	11.3%
O-	5689	7.0%
A-	4826	5.9%
AB+	2619	3.2%
B-	1484	1.8%
AB-	779	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
o	37742	46.4%
a	29570	36.3%
b	10702	13.1%
ab	3398	4.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

hemoglobin_level
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	77
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.19232791

Minimum	10.5
Maximum	18.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	10.5
5-th percentile	12.6
Q1	13.4
median	14.1
Q3	15
95-th percentile	16
Maximum	18.6
Range	8.1
Interquartile range (IQR)	1.6

Descriptive statistics

Standard deviation	1.059999933
Coefficient of variation (CV)	0.07468823574
Kurtosis	-0.4492654524
Mean	14.19232791
Median Absolute Deviation (MAD)	0.8
Skewness	0.1878605037
Sum	1155425.8
Variance	1.123599858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.6	2964	3.6%
13.9	2911	3.6%
13.7	2876	3.5%
13.8	2841	3.5%
13.5	2796	3.4%
14.1	2745	3.4%
14	2730	3.4%
14.2	2657	3.3%
13.4	2654	3.3%
13.3	2643	3.2%
Other values (67)	53595	65.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.5	2	< 0.1%
10.8	2	< 0.1%
10.9	3	< 0.1%
11	5	< 0.1%
11.1	3	< 0.1%
11.2	18	< 0.1%
11.3	17	< 0.1%
11.4	33	< 0.1%
11.5	47	0.1%
11.6	71	0.1%

Value	Count	Frequency (%)
18.6	1	< 0.1%
18.2	2	< 0.1%
18.1	2	< 0.1%
18	1	< 0.1%
17.9	2	< 0.1%
17.8	2	< 0.1%
17.7	2	< 0.1%
17.6	7	< 0.1%
17.5	16	< 0.1%
17.4	32	< 0.1%

blood_transfusion
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	71697
1	9715

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	71697	88.1%
1	9715	11.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	71697	88.1%
1	9715	11.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

max_glu_serum
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.7 KiB

unknown	77159
norm	2049
>200	1179
>300	1025

Length

Max length	7
Median length	7
Mean length	6.843278632
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	unknown
3rd row	unknown
4th row	unknown
5th row	unknown

Common Values

Value	Count	Frequency (%)
unknown	77159	94.8%
norm	2049	2.5%
>200	1179	1.4%
>300	1025	1.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	77159	94.8%
norm	2049	2.5%
200	1179	1.4%
300	1025	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

A1Cresult
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.7 KiB

unknown	67807
>8	6547
norm	4003
>7	3055

Length

Max length	7
Median length	7
Mean length	6.26277453
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	unknown
2nd row	>7
3rd row	unknown
4th row	>8
5th row	unknown

Common Values

Value	Count	Frequency (%)
unknown	67807	83.3%
>8	6547	8.0%
norm	4003	4.9%
>7	3055	3.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	67807	83.3%
8	6547	8.0%
norm	4003	4.9%
7	3055	3.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diuretics
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	79893
1	1519

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	79893	98.1%
1	1519	1.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	79893	98.1%
1	1519	1.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

insulin
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

1	44360
0	37052

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	44360	54.5%
0	37052	45.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	44360	54.5%
0	37052	45.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

change
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	43772
1	37640

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	43772	53.8%
1	37640	46.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	43772	53.8%
1	37640	46.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diabetesMed
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

1	62718
0	18694

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	62718	77.0%
0	18694	23.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	62718	77.0%
0	18694	23.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

readmitted
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	715.5 KiB

False	72340
True	9072

Common Values
Chart

Value	Count	Frequency (%)
False	72340	88.9%
True	9072	11.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_emergency	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
admission_id
0	199042938	white	male	50-60	unknown	elective	discharged_home	referral	1	unknown	unknown	0	Complete	24.0	3	9.0	0	0	0	721	250.6	357	5	A+	14.5	0	unknown	unknown	0	0	0	1	False
1	91962954	white	male	80-90	unknown	urgent	discharged_home	emergency	3	insured	emergency/trauma	0	Complete	50.0	0	8.0	0	0	1	276	507	150	9	B+	15.7	0	unknown	>7	0	0	0	0	True
2	109707084	white	female	60-70	unknown	emergency	discharged_home	emergency	5	insured	unknown	0	Complete	43.0	6	28.0	0	0	0	414	490	250	6	O+	13.0	0	unknown	unknown	0	1	1	1	False
3	157495374	black	female	70-80	unknown	n/a	discharged_home	unknown	2	unknown	unknown	0	Complete	58.0	5	8.0	0	1	1	577	585	250	9	AB-	13.5	0	unknown	>8	0	0	0	1	False
4	82692360	white	female	unknown	unknown	emergency	transferred_inpatient	emergency	12	insured	unknown	0	Complete	56.0	1	16.0	0	0	2	531	532	562	8	A+	13.0	0	unknown	unknown	0	0	0	0	False
5	218016576	white	female	70-80	unknown	urgent	discharged_home	referral	4	insured	unknown	0	Incomplete	14.0	3	13.0	0	0	0	578	280	562	9	A+	13.1	0	unknown	unknown	0	0	0	1	True
6	143084970	white	male	60-70	unknown	emergency	discharged_home	emergency	6	insured	unknown	0	Complete	62.0	0	21.0	0	0	0	482	428	276	9	A-	14.2	0	unknown	>7	0	1	0	1	False
7	227644092	unknown/other	female	70-80	unknown	elective	discharged_home	referral	11	unknown	internalmedicine	0	Incomplete	18.0	4	9.0	1	0	1	V57	438	599	6	O+	12.9	0	unknown	unknown	0	0	0	0	False
8	77740434	white	female	70-80	unknown	emergency	transferred_inpatient	emergency	2	insured	unknown	0	Complete	36.0	0	9.0	0	0	3	250.8	682	496	6	O-	13.9	0	unknown	unknown	0	1	0	1	False
9	203123016	white	female	40-50	unknown	elective	discharged_home	referral	2	unknown	unknown	0	Complete	5.0	2	25.0	0	0	0	433	362	401	9	A+	13.2	0	unknown	unknown	0	1	1	1	False

Last rows

	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_emergency	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
admission_id
81402	155324556	unknown/other	male	50-60	unknown	emergency	discharged_home	emergency	3	insured	unknown	0	Incomplete	1.0	0	13.0	0	0	0	682	250.82	707	9	O+	16.7	0	unknown	unknown	0	1	0	1	False
81403	224478630	black	female	80-90	unknown	elective	home_care	referral	7	unknown	unknown	0	Complete	35.0	2	37.0	0	2	0	440	707	401	4	A+	13.8	0	unknown	unknown	0	1	1	1	True
81404	228104460	black	female	50-60	unknown	elective	discharged_home	referral	3	unknown	obstetricsandgynecology	0	Complete	8.0	2	12.0	0	0	0	218	218	626	9	AB-	12.8	0	unknown	unknown	0	0	0	1	False
81405	48436146	black	female	40-50	unknown	emergency	discharged_home	emergency	6	insured	nephrology	0	Incomplete	35.0	3	22.0	0	0	0	595	591	V45	9	B+	11.4	0	unknown	unknown	0	1	0	1	False
81406	91915884	white	female	80-90	unknown	emergency	transferred_inpatient	emergency	4	insured	unknown	0	Complete	46.0	0	11.0	0	0	0	584	276	272	9	A+	13.8	0	unknown	unknown	0	1	0	1	False
81407	80746578	white	male	60-70	unknown	emergency	transferred_inpatient	emergency	2	insured	unknown	0	Complete	64.0	0	22.0	0	0	3	486	496	250.92	5	O+	15.4	0	unknown	unknown	0	1	1	1	False
81408	221853996	black	female	70-80	unknown	emergency	home_care	emergency	8	insured	internalmedicine	0	Complete	62.0	2	19.0	0	0	1	440	401	276	9	O+	12.8	0	unknown	unknown	0	1	1	1	False
81409	104846580	black	female	60-70	unknown	emergency	transferred_inpatient	emergency	5	unknown	unknown	0	Complete	1.0	2	14.0	0	0	0	822	403	250.6	9	B+	13.0	0	unknown	unknown	0	0	0	0	True
81410	229820346	white	female	50-60	unknown	elective	discharged_home	referral	1	unknown	unknown	0	Complete	30.0	1	10.0	0	0	0	996	753	250	7	AB+	13.3	1	unknown	unknown	0	0	0	1	False
81411	49302180	black	female	40-50	unknown	emergency	discharged_home	emergency	3	unknown	internalmedicine	0	Complete	43.0	0	14.0	0	0	0	250.12	198	V10	4	B+	12.4	0	unknown	unknown	0	1	1	1	False

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks